package com.vt.exel;

import com.vt.exel.pattern.PatternReadFromSheets;

/**
 * 
 * @author Vit
 * 
 */
public class Main {
	/**
	 * @param Здесь параметры не задействуются
	 */
	public static void main(String[] args) {
		PatternReadFromSheets fromSheets = new PatternReadFromSheets();
		fromSheets.addSheetMetrics(0, 1, true, 10, 11);
		fromSheets.addSheetMetrics(1, 1, true, 9, 10);
		fromSheets.addSheetMetrics(2, 1, true, 9, 10);
		fromSheets.addSheetMetrics(3, 1, true, 9, 10);
		fromSheets.addSheetMetrics(4, 1, false, 9, 10);
		fromSheets.addSheetMetrics(5, 1, false, 8, 9);
		fromSheets.addSheetMetrics(6, 1, true, 10, 11);
		ExelExtractor exelExtractor = new ExelExtractor();
		exelExtractor.exelReading("C:\\Exel\\load.xls", fromSheets);
		exelExtractor.verifyEmpty("C:\\Exel\\EmptyPositions.xls");
		exelExtractor.verifyErrors("C:\\Exel\\ErrorPositions.xls");
		exelExtractor.getListForUpload("C:\\Exel\\PositionsForUpload.xls");
		exelExtractor.uploadToDB();
	}
}
